Tabela MedResourceAddOns

Definicja tabeli MedResourceAddOns

Name

MedResourceAddOns

Code

MedResourceAddOns

Comment

PL: Tabela na dodatkowe informacje dotyczace ograniczen zasobu medycznego
EN: Table for additional information regarding medical resource limitations.
DE: Die Tabelle fur die ergänzenddien Informationen hinsichtlich die Abgrenzung des ärztlichen Ausweg.


Lista kolumn tabeli MedResourceAddOns

Name

Code

MedResourceAddOnsID

MedResourceAddOnsID

Sex

Sex

MedResourceID

MedResourceID

StartDT

StartDT

StopDT

StopDT

AgeTop

AgeTop

AgeBottom

AgeBottom


Kolumna MedResourceAddOnsID tabeli MedResourceAddOns

Definicja kolumny MedResourceAddOnsID tabeli MedResourceAddOns

Name

MedResourceAddOnsID

Code

MedResourceAddOnsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Sex tabeli MedResourceAddOns

Definicja kolumny Sex tabeli MedResourceAddOns

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

PL: Plec
EN: Sex of the person
DE: das Geschlecht


Kolumna MedResourceID tabeli MedResourceAddOns

Definicja kolumny MedResourceID tabeli MedResourceAddOns

Name

MedResourceID

Code

MedResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli MedResourceAddOns

Definicja kolumny StartDT tabeli MedResourceAddOns

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli MedResourceAddOns

Definicja kolumny StopDT tabeli MedResourceAddOns

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna AgeTop tabeli MedResourceAddOns

Definicja kolumny AgeTop tabeli MedResourceAddOns

Name

AgeTop

Code

AgeTop

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AgeBottom tabeli MedResourceAddOns

Definicja kolumny AgeBottom tabeli MedResourceAddOns

Name

AgeBottom

Code

AgeBottom

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli MedResourceAddOns

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MedResourceAddOns

Definicja klucza Identifier_1 tabeli MedResourceAddOns

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment